SUPPORT / SAMPLES & SAS NOTES
Problem Note 61322: Switching templates in a clustered worksheet triggers a database error
 |  |  |  |
In SAS® Merchandise Planning, switching templates in a clustered worksheet triggers a database error code 1020001. Below are the error details:
<LogMsg Type='Error' Uptime='48'>SQLERROR[-1:Native Error 20001 [SAS Ins. Inc.][ODBC 20101 driver][Oracle]ORA-20001: ORA-20001: Wrong CL_HIST_BUILD_BY_TIME_GROUP_COUNT value: 1. Should be between 1 and the count of TIME IDs in the worksheet (p_get_cl_hist(21002,2021,11,-1,-1,0,OUT), SQL#<LogDetails File='ODBCDatabase.cpp' Line='1617' LocalTime='Mon Oct 30 14:21:47 2017' SystemTime='1509387707' /></LogMsg>
<LogMsg Type='Warning' Uptime='48'>Native Error 20001 [SAS Ins. Inc.][ODBC 20101 driver][Oracle]ORA-20001: ORA-20001: Wrong CL_HIST_BUILD_BY_TIME_GROUP_COUNT value: 1. Should be between 1 and the count of TIME IDs in the worksheet (p_get_cl_hist(21002,2021,11,-1,-1,0,OUT), SQL#:1000)
ORA-06512: at MAXDATA.P_GET_CL_HIST , line 1811
ORA-06512: at line 1<LogDetails Error='1020001' Facility='Database' File='ODBCDatabase.cpp' Line='1617' LocalTime='Mon Oct 30 14:21:47 2017' SystemTime='1509387707' /></LogMsg>
<LogMsg Type='Warning' Uptime='48'>Native Error 20001 [SAS Ins. Inc.][ODBC 20101 driver][Oracle]ORA-20001: ORA-20001: Wrong CL_HIST_BUILD_BY_TIME_GROUP_COUNT value: 1. Should be between 1 and the count of TIME IDs in the worksheet (p_get_cl_hist(21002,2021,11,-1,-1,0,OUT), SQL#:1000)
ORA-06512: at MAXDATA.P_GET_CL_HIST , line 1811
ORA-06512: at line 1<LogDetails Error='1020001' Facility='Database' File='ODBCDatabase.cpp' Line='1617' LocalTime='Mon Oct 30 14:21:47 2017' SystemTime='1509387707' /></LogMsg>
If you identify a template that triggers this error, add the system default task to the template to prevent the error from being triggered.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Merchandise Financial Planning | Microsoft Windows Server 2012 R2 Std | 6.7 | 6.8 | 9.4 TS1M4 | 9.4 TS1M5 |
| 64-bit Enabled AIX | 6.7 | 6.8 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Linux for x64 | 6.7 | 6.8 | 9.4 TS1M4 | 9.4 TS1M5 | ||